package com.william.jdbcplus.generator.entity;

import com.william.jdbcplus.common.annotation.Table;
import com.william.jdbcplus.common.annotation.TableColumn;
import com.william.jdbcplus.common.annotation.TableId;
import com.william.jdbcplus.common.entity.Entity;
import com.william.jdbcplus.common.enums.IdType;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.Date;

/**
 * excel_report_db
 *
 * @author niliwei
 * @date 2020-11-23 10:11:00
 */
@Data
@NoArgsConstructor
@Table(value = "excel_report_db", remarks = "excel_report_db")
public class ExcelReportDb implements Entity {

    @TableId(value = "id", remarks = "id", type = IdType.ATOMIC, size = 36)
    private String id;

    @TableColumn(value = "report_id", remarks = "主键字段", size = 32)
    private String reportId;

    @TableColumn(value = "create_by", remarks = "创建人登录名称")
    private String createBy;

    @TableColumn(value = "update_by", remarks = "更新人登录名称")
    private String updateBy;

    @TableColumn(value = "create_time", remarks = "创建日期")
    private Date createTime;

    @TableColumn(value = "update_time", remarks = "更新日期")
    private Date updateTime;

    @TableColumn(value = "db_code", remarks = "数据集编码", size = 32)
    private String dbCode;

    @TableColumn(value = "db_ch_name", remarks = "数据集名字")
    private String dbChName;

    @TableColumn(value = "db_type", remarks = "数据源类型", size = 32)
    private String dbType;

    @TableColumn(value = "db_table_name", remarks = "数据库表名", size = 32)
    private String dbTableName;

    @TableColumn(value = "db_dyn_sql", remarks = "动态查询SQL", size = 2147483647)
    private String dbDynSql;

    @TableColumn(value = "db_key", remarks = "数据源KEY", size = 32)
    private String dbKey;

    @TableColumn(value = "tb_db_key", remarks = "填报数据源", size = 32)
    private String tbDbKey;

    @TableColumn(value = "tb_db_table_name", remarks = "填报数据表", size = 32)
    private String tbDbTableName;

    @TableColumn(value = "java_type", remarks = "java类数据集  类型（spring:springkey,class:java类名）", size = 32)
    private String javaType;

    @TableColumn(value = "java_value", remarks = "java类数据源  数值（bean key/java类名）", size = 255)
    private String javaValue;

    @TableColumn(value = "api_url", remarks = "请求地址", size = 255)
    private String apiUrl;

    @TableColumn(value = "api_method", remarks = "请求方法0-get,1-post", size = 255)
    private String apiMethod;

    @TableColumn(value = "is_page", remarks = "是否作为分页,0:不分页，1:分页", size = 10)
    private String isPage;

    @TableColumn(value = "db_source", remarks = "数据源", size = 255)
    private String dbSource;

}